
USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[LeagueDeleteLeagueId]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.LeagueDeleteLeagueId
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 11/03/08
-- Description:	LeagueDeleteLeagueId Select
-- =============================================
CREATE PROCEDURE LeagueDeleteLeagueId

	@LeagueId int
		   
AS
BEGIN

DELETE FROM Leagues
WHERE LeagueId = @LeagueId

END
GO

--    LeagueSelectByLeagueId 1